Search TipsSubscription Features
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
|
Subscription Number |
Y |
Numeric |
8,0 |
CMP Subscription Number |
|
Feature Code |
Y |
Alphanumeric |
6.0 |
Unique CMP code for the feature, for example, LOSTBR |
| Feature Description | Alphanumeric | 30, 0 | Text description of the CMP feature code, for example,Lost Phone Bar | |
|
Feature Enabled |
|
Numeric |
1 |
Whether the feature is enabled. Either 1=Yes or 0=No |
|
Feature Barred |
|
Numeric |
1 |
Whether the feature is enabled. Either 1=Yes or 0=No |
|
Feature Activity Pending |
|
Numeric |
1 |
Is any activity pending for the feature? Either 1=Yes or 0=No |
|
Date Time Created |
|
Numeric |
25,0 |
Date record created in CMP. YYYY-MM-DD HH:MM:SS format |
|
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
Date Time Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD HH:MM:SS format |
|
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |